Děkujeme Maiwaldova akademie'; $msg_simple_ok_text = 'Váš dotaz byl úspěšně odeslán.'; // anti spam $aspm = isset($_POST['aspm']) && $_POST['aspm']!='' ? $_POST['aspm'] : false; $my_code = 6 * SubStr(GetEnv('REMOTE_ADDR'),0,2); if(isset($_POST['akce']) && $_POST['akce'] == 'sendForm2' && $aspm==$my_code && $email) { // if not send requiure data & print error if (!$email) { $neodesilat = 'oki'; $odesilaci_hlaska = '
'.$msg_nok_text.'
'; } else { $adresat = 'ma@klasterbroumov.cz'; $dnesni_datum = date("H:i m.d.y"); $predmet = 'Dotaz z Maiwaldovy akademie'; /* if($email) { $odesilaci_email = $email; } else { */ $odesilaci_email = "info@ma.klasterbroumov.cz"; /* } */ /* $headers = 'MIME-Version: 1.0' . "\r\n" . 'X-Mailer: PHP/' . phpversion() . "\r\n" . 'Content-type: text/html; charset=utf-8' . "\r\n" . 'From: Maiwaldova akademie <' . $odesilaci_email . '>' . "\r\n" . 'Reply-To: Maiwaldova akademie <' . $odesilaci_email . '>'; */ /* $mail_par = "-f $odesilaci_email"; */ // html email $dopis = "

Dotaz z Maiwaldovy akademie

$jmeno <$email> se ptá:

$dotaz

Hezký den,
Váš Robot

"; /* Mail($adresat,$predmet,$dopis,$headers); */ require 'adm2/mailer/class.phpmailer.php'; $mail = new PHPMailer; $mail->IsSMTP(); $mail->SMTPAuth = true; $mail->Host = 'posta.pixman.cz'; $mail->Port = 25; $mail->Username = 'smtp@pixman.eu'; $mail->Password = 'PixmaniSMTP.*'; $mail->From = 'smtp@pixman.eu'; $mail->FromName = 'Maiwaldova akademie'; $mail->AddAddress($adresat, 'Maiwaldova akademie'); $mail->AddBCC('jarda@pixman.cz'); $mail->AddReplyTo($email, $jmeno); $mail->IsHTML(true); $mail->Subject = $predmet; $mail->Body = $dopis; $msg_nok_text = 'Zpráva nebyla odeslána.'; $msg_ok_text = 'Zpráva byla odeslána.'; if(!$mail->Send()) { // print success info $odesilaci_hlaska = '
'.$msg_nok_text.'
'; } else { // print success info $odesilaci_hlaska = '
'.$msg_ok_text.'
'; // clear contacts $email = $jmeno = $dotaz = ""; } } } // END - contact form // eshop code // cart $cart_arr = array(); $msg_cart = false; $product_exist = false; // order vars $jmeno = handleSessions('jmeno'); $prijmeni = handleSessions('prijmeni'); $ulice = handleSessions('ulice'); $mesto = handleSessions('mesto'); $psc = handleSessions('psc'); $zeme = handleSessions('zeme'); $telefon = handleSessions('telefon'); $email = handleSessions('email'); $poznamky = handleSessions('poznamky'); $email = handleSessions('email'); $firma = handleSessions('firma'); $doruceni = handleSessions('doruceni'); $platba = handleSessions('platba'); $zastupce = handleSessions('zastupce'); $narozeni = handleSessions('narozeni'); $platbasend = handleSessions('platbasend'); $ico = handleSessions('ico2'); $dic = handleSessions('dic2'); $jmeno2 = handleSessions('jmeno2'); $prijmeni2 = handleSessions('prijmeni2'); $ulice2 = handleSessions('ulice2'); $mesto2 = handleSessions('mesto2'); $psc2 = handleSessions('psc2'); $zeme2 = handleSessions('zeme2'); $firma2 = handleSessions('firma2'); $ico2 = handleSessions('ico2'); $dic2 = handleSessions('dic2'); // eshop end // conf types $send_url = $_SERVER['REQUEST_URI']; // def. get params $get_m = false; // check if url contain params (?) $send_parms = $sql_main_get = false; $pos = strpos($send_url, '?'); if ($pos !== false) { $tmp_arr = explode('?',$send_url); $send_url = trim($tmp_arr[0]); // handle params $send_parms = trim($tmp_arr[1]); $params_arr = explode('&',$send_parms); // main catogories foreach ($params_arr as $key => $value_get) { $value_get = urldecode($value_get); $tmp_value_arr = explode('=',$value_get); $value = $tmp_value_arr[1]; $key = $tmp_value_arr[0]; if ($value!='') { // send month for 'news' if ($key=='m') { $get_m = FixInt($value); } // send year for 'stalo se' if ($key=='y') { $get_y = FixInt($value); } } } } // conf types if (substr($send_url,-1)=='/') $send_url = substr($send_url,0,-1); $page_arr = explode('/',$send_url); $url_pos = $page_arr[count($page_arr)-1]!='' ? 1 : 2; // detect '/' at last char $page_link = $page_arr[count($page_arr)-$url_pos]; // detect page key $page_lang = $page_arr[count($page_arr)-($url_pos+1)]; // detect page key $page_id = $page_type = $page = $table = $title = $descr = $title_seo = $descr_seo = $page_top = $category_id = $product_id = $realizace_id = $vyrobce_id = $designer_id = $high_category = $types_id = $category_main_id = $aktuality_id = $breadcrumb = $oteviraci_doba = $oteviraci_doba_text = false; $page_url_arr = $types_arr = $types_url_arr = $types_top_arr = $category_arr = $category_url_arr = $category_top_arr = $pages_arr = $pages_url_arr = $pages_top_arr = $produkt_arr = $pages_perex_arr = $data_url_arr = $footer_arr = $footer_text_arr = $high_category_arr = $data_typzobrazeni_arr = $slideshow_arr = $slideshow_url_arr = array(); $conf_dostupnost_arr = array(1=>'Skladem (3-5 dní)',2=>'2 - 6 týdnů',3=>'4 - 8 týdnů',4=>'6 - 8 týdnů',5=>'6 - 10 týdnů',6=>'8 - 10 týdnů',7=>'Nedostupné',8=>'Neznámý'); $typ_produktu = false; $homepage_id = 3; $page_programy = 52; $page_osveta = 5; $page_akademie = 6; $page_sluzby = 7; $page_lapidarium = 57; $page_o_nas = 8; $page_hledani = 9; $page_partneri = 10; $page_404 = 11; $page_klaster_id = 25; $page_kontakt = 51; // detect language if ($page_link=='en' || $page_lang=='en') { $lang_sql_str = '1'; $lang = 'en'; $language_link = 'en/'; include "inc/lang-en.php"; } else if ($page_link=='de' || $page_lang=='de') { $lang_sql_str = '3'; $lang = 'de'; $language_link = 'de/'; include "inc/lang-de.php"; } else if ($page_link=='pl' || $page_lang=='pl') { $lang_sql_str = '2'; $lang = 'pl'; $language_link = 'pl/'; include "inc/lang-pl.php"; } else { $lang_sql_str = ''; $lang = 'cs'; $language_link = 'cs/'; include "inc/lang-cs.php"; } $this_url = 'http://'.$_SERVER["SERVER_NAME"].'/'.$language_link.$page_link; // main catogories if ($page_link == 'ma.cz' || $page_link == 'index.php' || in_array($page_link,$conf_web_domains) || $page_link == '' || $page_link=='cs' || $page_link=='en' || $page_link=='de' || $page_link=='pl') { $page = 'homepage'; $page_url_arr = array('cs'=>'../','en'=>'../en/','pl'=>'../pl/','de'=>'../de/'); $table = 'ma'; $page_id = $homepage_id; // homepage content $homepage_arr = $homepage_text_arr = $homepage_link_arr = array(); $i = 0; // for all pages read products pages for top menu (cache?) $sSql = "SELECT * FROM ma WHERE status='1' ORDER BY razeni"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // if not set page icon use page title $ikona_tmp = printSqlCol('ikona'.$lang_sql_str,$zaznam); $pages_arr[$zaznam['id']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('titulek'.$lang_sql_str,$zaznam); $pages_url_arr[$zaznam['id']] = $root.$language_link.printSqlCol('link'.$lang_sql_str,$zaznam); $pages_perex_arr[$zaznam['id']] = printSqlCol('perex'.$lang_sql_str,$zaznam); // if set, add link to this page as subpage $pages_top_arr[$zaznam['id']] = printSqlCol('idhlavnistranky',$zaznam); // if this page == current -> set page type if ($zaznam['id']==$homepage_id) { $page_type = printSqlCol('idtypustranky',$zaznam); $page_top = printSqlCol('idhlavnistranky',$zaznam); if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam); $perex = printSqlCol('perex'.$lang_sql_str,$zaznam); $text = printSqlCol('popis'.$lang_sql_str,$zaznam); } $i = 0; if ($zaznam['idhlavnistranky']==$homepage_id) { $homepage_link_arr[$i] = printSqlCol('perex'.$lang_sql_str,$zaznam); $homepage_text_arr[$i] = utf8_substr_word(strip_tags(printSqlCol('popis'.$lang_sql_str,$zaznam)),200,'').'...'; $homepage_arr[$i] = printSqlCol('id',$zaznam); $pages_pcs_arr[$zaznam['id']] = printSqlCol('soubor',$zaznam); $i++; } // add slideshow if (isset($zaznam['idtypustranky']) && $zaznam['idtypustranky']==4) { $slideshow_arr[$zaznam['id']] = printSqlCol('perex'.$lang_sql_str,$zaznam); $slideshow_url_arr[$zaznam['id']] = printSqlCol('ikona'.$lang_sql_str,$zaznam); } // add footers if (isset($zaznam['idtypustranky']) && $zaznam['idtypustranky']==5) { $footer_arr[] = printSqlCol('titulek'.$lang_sql_str,$zaznam); $footer_text_arr[] = printSqlCol('popis'.$lang_sql_str,$zaznam); } } // pictures for homepage $sSql = "SELECT * FROM maobsah WHERE idzaznamu='$homepage_id' ORDER BY razeni"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $data_title_arr[$zaznam['id']] = printSqlCol('titulek'.$lang_sql_str,$zaznam); $data_video_arr[$zaznam['id']] = printSqlCol('video',$zaznam); $data_www_arr[$zaznam['id']] = printSqlCol('www',$zaznam); $data_rozmery_arr[$zaznam['id']] = printSqlCol('rozmery',$zaznam); $data_pcs_wh_arr[$zaznam['id']] = $zaznam['rozmery'][0]=='w' ? ' height="100%"' : ' width="100%"'; $data_typzobrazeni_arr[$zaznam['id']] = printSqlCol('typzobrazeni',$zaznam); $data_text_arr[$zaznam['id']] = printSqlCol('popis'.$lang_sql_str,$zaznam); $data_pcs_arr[$zaznam['id']] = isset($zaznam['soubor']) && $zaznam['soubor'] ? StripSlashes($zaznam['soubor']) : ''; $data_color_arr[$zaznam['id']] = StripSlashes($zaznam["cernabila"]); } } else { // found url in db $sSql = "SELECT * FROM url WHERE url$lang_sql_str='$page_link'"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // page conf $page = printSqlCol('url'.$lang_sql_str,$zaznam); $page_id = printSqlCol('idzaznamu',$zaznam); $table = printSqlCol('tabulka',$zaznam); // links to other langs $page_url_arr = array('cs'=>$root.'cs/'.printSqlCol('url',$zaznam),'en'=>$root.'en/'.printSqlCol('url1',$zaznam),'pl'=>$root.'pl/'.printSqlCol('url2',$zaznam),'de'=>$root.'de/'.printSqlCol('url3',$zaznam)); // seo for cur. page in cur. lang $title_seo = printSqlCol('title'.$lang_sql_str,$zaznam); $descr_seo = printSqlCol('descr'.$lang_sql_str,$zaznam); } //echo ''; // for all pages read products category for top menu (cache?) $sSql = "SELECT * FROM kategorie WHERE status='1' ORDER BY razeni"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $ikona_tmp = printSqlCol('ikona'.$lang_sql_str,$zaznam); $category_arr[$zaznam['id']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('titulek'.$lang_sql_str,$zaznam); $category_url_arr[$zaznam['id']] = $root.$language_link.printSqlCol('link'.$lang_sql_str,$zaznam); $category_top_arr[$zaznam['id']] = printSqlCol('idnadkategorie',$zaznam); // if this category == current -> set page type if ($page_id>0 && $zaznam['id']==$page_id && $table=='kategorie') { if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam); } } // for all pages read products pages for top menu (cache?) $sSql = "SELECT * FROM ma WHERE status='1' ORDER BY razeni"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { // if not set page icon use page title $ikona_tmp = printSqlCol('ikona'.$lang_sql_str,$zaznam); $pages_arr[$zaznam['id']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('titulek'.$lang_sql_str,$zaznam); $pages_url_arr[$zaznam['id']] = printSqlCol('link'.$lang_sql_str,$zaznam); $pages_perex_arr[$zaznam['id']] = utf8_substr_word(strip_tags(printSqlCol('perex'.$lang_sql_str,$zaznam).' '.printSqlCol('popis'.$lang_sql_str,$zaznam)),200,'').'...'; $pages_pcs_arr[$zaznam['id']] = printSqlCol('soubor',$zaznam); // if set, add link to this page as subpage $pages_top_arr[$zaznam['id']] = printSqlCol('idhlavnistranky',$zaznam); // if this page == current -> set page type if ($page_id>0 && $zaznam['id']==$page_id && $table=='ma') { $page_type = printSqlCol('idtypustranky',$zaznam); $page_top = printSqlCol('idhlavnistranky',$zaznam); if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam); $perex = printSqlCol('perex'.$lang_sql_str,$zaznam); $text = printSqlCol('popis'.$lang_sql_str,$zaznam); } // add footers if (isset($zaznam['idtypustranky']) && $zaznam['idtypustranky']==5) { $footer_arr[] = printSqlCol('titulek'.$lang_sql_str,$zaznam); $footer_text_arr[] = printSqlCol('popis'.$lang_sql_str,$zaznam); } } if ($table=='produkty' && $page_id>0) { // list product detail $tmp_product_idkategorie = false; $cena = $kontaktni_osoba = $kapacita = $kod = ''; $vysledek = Pg_Exec("SELECT * FROM produkty WHERE id = '$page_id' AND status>0"); if ($vysledek) { $zaznam = @Pg_Fetch_Array($vysledek,0); if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam); $perex = printSqlCol('perex'.$lang_sql_str,$zaznam); $text = printSqlCol('popis'.$lang_sql_str,$zaznam); $typ_produktu = printSqlCol('idtypu',$zaznam); // top ID (idkategorie, idaktuality, idpoi) $tmp_product_idkategorie = printSqlCol('idkategorie'.$lang_sql_str,$zaznam); // price & info $kod = printSqlCol('kod',$zaznam); $cena = printSqlCol('cena',$zaznam); $kontaktni_osoba = printSqlCol('iduzivatele',$zaznam); $kapacita = printSqlCol('kapacita',$zaznam); $trvani = isset($zaznam['trvani']) && $zaznam['trvani'] ? intval($zaznam['trvani']) / 60 : false; // reservation $od = $od_cs = $do = $do_cs = false; $od = printSqlCol('datumod',$zaznam); if ($od) $od_cs = GetCzDateShortFree($od); $do = printSqlCol('datumdo',$zaznam); if ($do) $do_cs = GetCzDateShortFree($do); // search page $tmp_product_page = false; $vysledek = Pg_Exec("SELECT * FROM maprodukt WHERE idproduktu = '$page_id'"); if ($vysledek) { $zaznam = @Pg_Fetch_Array($vysledek,0); $tmp_product_page = printSqlCol('idzaznamu',$zaznam); } } // breadcrumb for product // 1st level $breadcrumb = $title; if ($tmp_product_page) { // maprodukt / idproduktu / idzaznamu // 2nd level if (isset($pages_arr[$tmp_product_page]) && $pages_arr[$tmp_product_page]) { //if (isset($pages_top_arr[$tmp_product_page]) && $pages_top_arr[$tmp_product_page]>0) { //$breadcrumb = ''.$pages_arr[$pages_top_arr[$tmp_product_page]].' / '.$breadcrumb; $breadcrumb = ''.$pages_arr[$tmp_product_page].' / '.$breadcrumb; // 3rd level if (isset($pages_top_arr[$tmp_product_page])) { $tmp_top = $pages_top_arr[$tmp_product_page]; if (isset($pages_arr[$tmp_top]) && $pages_arr[$tmp_top]!='') $breadcrumb = ''.$pages_arr[$tmp_top].' / '.$breadcrumb; // 4th level if (isset($pages_top_arr[$tmp_top])) { $tmp_top = $pages_top_arr[$tmp_top]; if (isset($pages_arr[$tmp_top]) && $pages_arr[$tmp_top]!='') $breadcrumb = ''.$pages_arr[$tmp_top].' / '.$breadcrumb; } } } } else if ($tmp_product_idkategorie) { // maprodukt / idproduktu / idzaznamu // 2nd level if (isset($category_arr[$tmp_product_idkategorie]) && $category_arr[$tmp_product_idkategorie]!='') { $breadcrumb = ''.$category_arr[$tmp_product_idkategorie].' / '.$breadcrumb; $product_cat_name = $category_arr[$tmp_product_idkategorie]; } } } else if ($table=='kategorie') { // eshop cat breadcrumb if (isset($category_top_arr[$page_id]) && $category_top_arr[$page_id]>0) { $breadcrumb = ''.$category_arr[$category_top_arr[$page_id]].' / '.$title; } else { $breadcrumb = ''.$title.''; } } else if ($table=='ma') { // breadcrumb // 1st level $breadcrumb = $pages_arr[$page_id]; /* echo $page_id.'---'; echo 'pages_arr'; print_r($pages_arr); echo 'pages_top_arr'; print_r($pages_top_arr); */ // 2nd level if (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]>0) { $breadcrumb = ''.$pages_arr[$pages_top_arr[$page_id]].' / '.$breadcrumb; // 3rd level if (isset($pages_top_arr[$pages_top_arr[$page_id]])) { $tmp_top = $pages_top_arr[$pages_top_arr[$page_id]]; if (isset($pages_arr[$tmp_top]) && $pages_arr[$tmp_top]!='') $breadcrumb = ''.$pages_arr[$tmp_top].' / '.$breadcrumb; // 4th level if (isset($pages_top_arr[$tmp_top])) { $tmp_top = $pages_top_arr[$tmp_top]; if (isset($pages_arr[$tmp_top]) && $pages_arr[$tmp_top]!='') $breadcrumb = ''.$pages_arr[$tmp_top].' / '.$breadcrumb; } } } } else { $breadcrumb = $title; } // add homepage to breadcrumb $breadcrumb = ''.$uvod_text.' / '.$breadcrumb; if ($table=='aktuality') { // DODELAT!!! } else { $sSql = "SELECT * FROM maobsah WHERE idzaznamu='$page_id' ORDER BY razeni"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $data_title_arr[$zaznam['id']] = printSqlCol('titulek'.$lang_sql_str,$zaznam); $data_video_arr[$zaznam['id']] = printSqlCol('video',$zaznam); $data_www_arr[$zaznam['id']] = printSqlCol('www',$zaznam); $data_rozmery_arr[$zaznam['id']] = printSqlCol('rozmery',$zaznam); $data_pcs_wh_arr[$zaznam['id']] = $zaznam['rozmery'][0]=='w' ? ' height="100%"' : ' width="100%"'; $data_typzobrazeni_arr[$zaznam['id']] = printSqlCol('typzobrazeni',$zaznam); $data_text_arr[$zaznam['id']] = printSqlCol('popis'.$lang_sql_str,$zaznam); $data_pcs_arr[$zaznam['id']] = isset($zaznam['soubor']) && $zaznam['soubor'] ? StripSlashes($zaznam['soubor']) : ''; $data_color_arr[$zaznam['id']] = StripSlashes($zaznam["cernabila"]); } } // get SEO & page data if ($page_id>0 && $table!='') { // read from db only if page not category or clasic page...ex.: "realizace", "produkty"... if ($table!='ma' && $table!='kategorie' && $table!='produkty') { $vysledek = Pg_Exec("SELECT * FROM $table WHERE id = '$page_id' AND status>0"); if ($vysledek) { $zaznam = @Pg_Fetch_Array($vysledek,0); if (!$title) $title = printSqlCol('titulek'.$lang_sql_str,$zaznam); $perex = printSqlCol('perex'.$lang_sql_str,$zaznam); $text = printSqlCol('popis'.$lang_sql_str,$zaznam); } } } } // 404 error page if (!$page) { $page = '404'; } // folder $inc_str = ''; // vars for jquery $count_top_banner_field = $final_end = ''; // echo $table.'---'.$realizace_id.'---'.$page_id; // banners if ($page=='homepage') { // search } else if ($table=='stranky' && $page_id==$page_hledani) { // product details } else if ($table=='produkty' && $page_id>0) { $idceny_arr = $idceny_cena_arr = array(); // list options $vlastnosti_arr = array(); $vysledek = Pg_Exec("SELECT * FROM vlastnosti ORDER BY razeni"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $vlastnosti_arr[$zaznam['id']] = StripSlashes($zaznam['titulek'.$lang_sql_str]); } // list options unit $jednotky_arr = array(); $vysledek = Pg_Exec("SELECT * FROM jednotky"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $jednotky_arr[$zaznam['id']] = StripSlashes($zaznam['titulek'.$lang_sql_str]); } // list options unit $ceny_arr = array(); $vysledek = Pg_Exec("SELECT * FROM ceny"); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $ceny_arr[$zaznam['id']] = StripSlashes($zaznam['titulek'.$lang_sql_str]); } // if send registration (jmeno, prijmeni, mesto, pcs, ulice, telefon, email) if (isset($_POST['aspm']) && $_POST['aspm'] && isset($_POST['registrace']) && $_POST['registrace']) { // define vars $rezervace_cas = $iduzivatele = $title = ''; // list rec. data $vysledek = Pg_Exec("SELECT * FROM produkty WHERE id = '$page_id'"); $zaznam = @Pg_Fetch_Array($vysledek,0); if ($zaznam) { // main data $title = printSqlCol('titulek'.$lang_sql_str,$zaznam); $odpoved = printSqlCol('odpoved'.$lang_sql_str,$zaznam); $cena = printSqlCol('cena',$zaznam); $cenasleva = printSqlCol('cenasleva',$zaznam); $dph = $conf_vat[printSqlCol('dan',$zaznam)]; // user & set email to $iduzivatele = printSqlCol('iduzivatele',$zaznam); // main email $mail_to = $conf_email_shop; $mail_to_arr = array(); // date & time & type $typ_produktu = printSqlCol('idtypu',$zaznam); $od = $od_cs = false; $od = printSqlCol('datumod',$zaznam); $do = printSqlCol('datumdo',$zaznam); if ($od) $od_cs = GetCzDateShortFree($od); if ($do) $do_cs = GetCzDateShortFree($do); if ($iduzivatele>0) { //$vysledek = Pg_Exec("SELECT * FROM lide WHERE id = '$iduzivatele'"); $vysledek = Pg_Exec("SELECT adresy.*,uzivatele.id AS uid FROM adresy,uzivatele WHERE adresy.id = uzivatele.idadresy AND uzivatele.id = '$iduzivatele'"); $zaznam_lide = @Pg_Fetch_Array($vysledek,0); if (isset($zaznam_lide['email']) && $zaznam_lide['email']!='' && CheckEmail(printSqlCol('email',$zaznam_lide))) $mail_to = printSqlCol('email',$zaznam_lide); } } // form values $jmeno = GetOrPostSafe('jmeno','post'); $prijmeni = GetOrPostSafe('prijmeni','post'); $telefon = GetOrPostSafe('telefon','post'); $email = GetOrPostSafe('email','post'); $firma = GetOrPostSafe('firma','post'); $ulice = GetOrPostSafe('ulice','post'); $mesto = GetOrPostSafe('mesto','post'); $psc = GetOrPostSafe('psc','post'); $zeme = GetOrPostSafe('zeme','post'); $poznamky = GetOrPostSafe('poznamky','post'); // children registration $zastupce = GetOrPostSafe('zastupce','post'); $narozeni = GetOrPostSafe('narozeni','post'); // product $registrace = GetOrPostSafe('registrace','post'); $potvrzeni = GetOrPostSafe('potvrzeni','post'); $pocet = GetOrPostSafe('pocet','post'); // date $datum = GetOrPostSafe('datum','post'); $datum_sql = date('Y-m-d',strtotime($datum)); $datum_sql_do = ''; // send order email // anti spam $aspm = isset($_POST['aspm']) && $_POST['aspm']!='' ? $_POST['aspm'] : false; $my_code = 6 * SubStr(GetEnv('REMOTE_ADDR'),0,2); $conf_spam_str = 'http:|roulette|viagra|cialis|blackjack|casino|bingo|poker|vijagra|vjagra|cripple|baccarat|backgammon'; $send_mail = false; //echo $my_code.'--'.$jmeno.'--'.$prijmeni.'--'.$telefon.'--'.$email.'--'.$cas.'--'.$datum; if(isset($_POST['akce']) && $_POST['akce'] == 'sendForm' && $aspm==$my_code && $jmeno && $prijmeni && $email && $ulice && $mesto) { $id2 = Pg_Exec("SELECT nextval('rezervace_id_seq');"); $id2 = Pg_Fetch_Array($id2,0); $id2 = $id2['nextval']; $pocet_celkem = $pocet; /* Notice: Undefined variable: cena1 in /var/www/clients/client37/web98/web/projekty/ma.cz/index.php on line 724 Notice: Undefined variable: cena2 in /var/www/clients/client37/web98/web/projekty/ma.cz/index.php on line 725 Warning: pg_exec(): Query failed: ERROR: date/time field value out of range: "1495231200" LINE 1: ....vrestiak@gmail.com','ČR','25088','Je','neni','2','149523120... ^ HINT: Perhaps you need a different "datestyle" setting. in /var/www/clients/client37/web98/web/projekty/ma.cz/index.php on line 730 */ // mail to customer $variabilni_symbol = sprintf('%04d', $id2); if (isset($odpoved) && $odpoved!='') $body2 = str_replace('GENEROVATVS',$variabilni_symbol,$odpoved); $cena1 = $cena * $pocet; // mail to eshop $subject = "Maiwaldova akademie - poptávka - $title\n"; $body = "Poptávka: $title\n"; $body .= isset($od) && $od && isset($do) && $do ? "Datum: $od_cs - $do_cs\n" : (isset($od) && $od ? "Datum: $od_cs\n" : ''); $body .= isset($datum) && $datum ? "Navržené datum: $datum\n" : ''; $body .= "Počet osob: $pocet\n"; $body .= "Cena osoba: $cena s $dph DPH\n"; $body .= "Data:\n"; $body .= "$jmeno;$prijmeni;$telefon;$email;$ulice $mesto $psc $zeme\n"; $body .= "Odkaz do administrace: http://www.monasterybroumov.cz/adm2/rezervace.php?id=$id2 \n"; $body .= "--------------------------\n"; // send options $vysledek = Pg_Exec("SELECT * FROM produktyvlastnosti WHERE idzaznamu = '$page_id'"); if (Pg_Num_Rows($vysledek)>0) $body .= "Další položky poptávky\n"; while ($zaznam = Pg_Fetch_Assoc($vysledek)) { if (isset($_POST['opt']) && in_array($zaznam['id'],$_POST['opt'])) { $str = strip_tags(printSqlCol('hodnota',$zaznam)); $str = substr($str,0,200).'...'; $str = html_entity_decode($str, ENT_QUOTES, "UTF-8"); $cena_opt = isset($zaznam['cena']) ? FixInt($zaznam['cena']) : 0; $cena_opt2 = isset($zaznam['cena2']) ? FixInt($zaznam['cena2']) : 0; $cena2 += $cena_opt2; $body .= "\n".$str."\n"; $body .= "Cena dospělí: ".$cena_opt.",- Kč (".$jednotky_arr[$zaznam['idjednotky']].") / Cena děti a zlevněné: ".$cena_opt2.",- Kč (".$jednotky_arr[$zaznam['idjednotky']].")\n"; if (isset($zaznam['email']) && $zaznam['email']!='' && CheckEmail(printSqlCol('email',$zaznam))) $mail_to_arr[] = printSqlCol('email',$zaznam); } } $body .= "--------------------------\n"; $body .= "Kontakt\n"; if ($firma!='') $body .= "Škola/Instituce: $firma\n"; if ($jmeno!='') $body .= "Jméno: $jmeno\n"; if ($prijmeni!='') $body .= "Příjmení: $prijmeni\n"; if ($narozeni!='') $body .= "Datum narození: $narozeni\n"; if ($telefon!='') $body .= "Telefon: $telefon\n"; if ($email!='') $body .= "Email: $email\n"; if ($ulice!='') $body .= "Ulice: $ulice\n"; if ($mesto!='') $body .= "Město: $mesto\n"; if ($psc!='') $body .= "PSČ: $psc\n"; if ($zeme!='') $body .= "Zeme: $zeme\n"; if ($zastupce!='') $body .= "Zákonný zástupce: $zastupce\n"; $body .= "--------------------------\n"; $body .= "Dotaz: $poznamky\n"; $body .= "--------------------------\n"; // mail to custommer $body2 = "Poptávka: $title\n"; $body2 .= isset($od) && $od && isset($do) && $do ? "Datum: $od_cs - $do_cs\n" : (isset($od) && $od ? "Datum: $od_cs\n" : "Navržené datum: $datum\n"); $body2 .= "Počet osob: $pocet\n"; $body2 .= "Cena osoba: $cena s $dph DPH\n"; $body2 .= "Dotaz: $poznamky\n"; // insert data to db if ($body) { $sendcommand = "INSERT INTO rezervace (id,datumnarozeni,zastupce,firma,jmeno,prijmeni,telefon,email,zeme,psc,mesto,ulice,pocetcelkem,datumod,datumdo,objednavka,poznamky,jazyk,cena,cena1,cena2,stav,ip,datumzadani,datumzmeny) VALUES ("; $sendcommand .= "'".AddSlashes($id2)."',"; $sendcommand .= "'".AddSlashes($narozeni)."',"; $sendcommand .= "'".AddSlashes($zastupce)."',"; $sendcommand .= "'".AddSlashes($firma)."',"; $sendcommand .= "'".AddSlashes($jmeno)."',"; $sendcommand .= "'".AddSlashes($prijmeni)."',"; $sendcommand .= "'".AddSlashes($telefon)."',"; $sendcommand .= "'".AddSlashes($email)."',"; $sendcommand .= "'".AddSlashes($zeme)."',"; $sendcommand .= "'".AddSlashes($psc)."',"; $sendcommand .= "'".AddSlashes($mesto)."',"; $sendcommand .= "'".AddSlashes($ulice)."',"; $sendcommand .= "'".AddSlashes($pocet_celkem)."',"; $sendcommand .= "'".AddSlashes($datum_sql)."',"; $sendcommand .= "'".AddSlashes($datum_sql_do)."',"; $sendcommand .= "'".AddSlashes($body)."',"; $sendcommand .= "'".AddSlashes($poznamky)."',"; $sendcommand .= "'".AddSlashes($lang)."',"; $sendcommand .= "'".AddSlashes($cena)."',"; $sendcommand .= "'".AddSlashes($cena1)."',"; $sendcommand .= "'".AddSlashes($cena2)."',"; $sendcommand .= "'1',"; $sendcommand .= "'".AddSlashes(GetEnv('REMOTE_ADDR'))."',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)"; $sendcommand = str_replace("''","NULL",$sendcommand); if (Pg_Exec($sendcommand)) { // link product to reservation $sql_product = ''; $sql_product .= "INSERT INTO rezervaceobsah (idrezervace,idproduktu) VALUES ('$id2','$page_id');"; Pg_Exec($sql_product); // insert opt. rec. $sql_opt = ''; if (isset($_POST['opt']) && count($_POST['opt'])>0) { foreach ($_POST['opt'] as $key => $value) { $sql_opt .= "INSERT INTO rezervacevlastnosti (idrezervace,idproduktyvlastnosti,pocet) VALUES ('$id2','$value',1);"; } } if ($sql_opt!='') Pg_Exec($sql_opt); $script_result = $registrace_byla_uspesne_odeslána_text; }else{ $script_result = $nepodarilo_se_odeslat_text; } } // load phpmailer and send mail require 'adm2/mailer/class.phpmailer.php'; $adresat = 'ma@klasterbroumov.cz'; $mail = new PHPMailer; // SMTP $mail->IsSMTP(); $mail->SMTPAuth = true; $mail->Host = 'posta.pixman.cz'; $mail->Port = 25; $mail->Username = 'smtp@pixman.eu'; $mail->Password = 'PixmaniSMTP.*'; $mail->From = 'smtp@pixman.eu'; $mail->FromName = 'Maiwaldova akademie'; $mail->AddAddress('ma@klasterbroumov.cz'); $mail->AddBCC('jarda@pixman.cz'); $mail->AddReplyTo($email, $jmeno+$prijmeni); // add all email from reservation options foreach ($mail_to_arr as $key => $value) { $mail->AddAddress($value); } $mail->Subject = $subject; $mail->Body = $body; if(!$mail->Send()) { echo 'Mailer Error: ' . $mail->ErrorInfo; } else { $send_mail = true; // send confirm mail to customer if ($email) { $mail = new PHPMailer; $mail->IsSMTP(); $mail->SMTPAuth = true; $mail->Host = 'posta.pixman.cz'; $mail->Port = 25; $mail->Username = 'smtp@pixman.eu'; $mail->Password = 'PixmaniSMTP.*'; $mail->From = 'smtp@pixman.eu'; $mail->FromName = 'Maiwaldova Akademie'; $mail->AddAddress($email); $mail->AddReplyTo('ma@klasterbroumov.cz'); $mail->Subject = $subject; $mail->Body = $body2; $mail->Send(); // clear fields $jmeno = $prijmeni = $telefon = $email = $ulice = $mesto = $psc = $zeme = $datum = $pocet = $narozeni = $zastupce = ''; } } } else { $script_result = $pro_odeslani_vyplnte_text; } } } ?> <? echo $title_seo ? $title_seo : $conf_title.' - '.$title ?>
$value) { $rec_arr[] = $key; } // list rec images foreach ($pages_top_arr as $key => $value) { if ($value == $page_programy) { $rec_arr[] = $key; } } if (count($rec_arr)>0) { $sql_podminka = implode(' OR idzaznamu=',$rec_arr); $sql_podminka = '(idzaznamu='.$sql_podminka.')'; $sSql = "SELECT soubor,idzaznamu,rozmery FROM maobsah WHERE rozmery IS NOT NULL AND soubor IS NOT NULL AND $sql_podminka ORDER BY razeni"; $vysledek2 = Pg_Exec($sSql); while ($zaznam2 = Pg_Fetch_Assoc($vysledek2)) { if (!isset($rec_pcs_arr[$zaznam2['idzaznamu']])) $rec_pcs_arr[$zaznam2['idzaznamu']] = StripSlashes($zaznam2['soubor']); } } ?>
$value) { $i++; ?>
$value) { $i++; ?>

<? echo $pages_arr[$homepage_arr[0]] ?>

<? echo $product_title ?>

$value) { // list subpages of cur. page if ($value == $page_programy) { ?>
<? echo $pages_arr[$key] ?>

<? echo $pages_arr[$page_klaster_id] ?>


>

1) { // prepare str. $hledani = strtr(strip_tags($hledani),$unicode_array); ?>

Stránky

'0' AND hledani ILIKE '%$hledani%' AND titulek$lang_sql_str IS NOT NULL ORDER BY razeni"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $i++; ?>

...



Vzdělávací programy

'0' AND hledani ILIKE '%$hledani%' AND titulek$lang_sql_str IS NOT NULL ORDER BY razeni"; $vysledek = Pg_Exec($sSql); while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $i++; ?>

...



$value) { // list subpages of cur. page if ($value == $page_id) { ?>
<? echo $pages_arr[$key] ?>



'.StripSlashes($zaznam2['titulek'.$lang_sql_str]).''; } else { $photos_str .= ''.StripSlashes($zaznam2['titulek'.$lang_sql_str]).''; } } else { $downloads_str .= ''.StripSlashes($zaznam2['titulek'.$lang_sql_str]).'
'; } } ?>



$value) { // list subpages of cur. page if ($value == $page_id) { ?>
<? echo $pages_arr[$key] ?>


'0' AND produkty.id = maprodukt.idproduktu AND maprodukt.idzaznamu='$page_id' ORDER BY produkty.datumod DESC"; $vysledek = Pg_Exec($sSql); $pocetzaznamu = Pg_Num_Rows($vysledek); if ($pocetzaznamu>0) { $last = 0; $time_break = 0; while ($zaznam = Pg_Fetch_Assoc($vysledek)) { $last++; $trvani = isset($zaznam['trvani']) && $zaznam['trvani'] ? intval($zaznam['trvani']) / 60 : false; $datum_od = isset($zaznam['datumod']) ? strtotime($zaznam['datumod']) : false; echo ''; // osvetova cinnost actual / old products if ($datum_od < time() && $time_break!=2 && $datum_od) { $time_break = 2; $last = 1; ?>

Uskutečněné akce


Plánované akce

...

Doba trvání: hod.
Cena: ,-Kč/žák



'; } else { $photos_str .= ''; } } else { $downloads_str .= ''.StripSlashes($zaznam2['titulek'.$lang_sql_str]).'
'; } } ?>

Doba trvání: hod.
Cena: ,-Kč/žák

0) { $vysledek = Pg_Exec("SELECT adresy.*,uzivatele.id AS uid FROM adresy,uzivatele WHERE adresy.id = uzivatele.idadresy AND uzivatele.id = '$kontaktni_osoba'"); $zaznam_lide = Pg_Fetch_Array($vysledek,0); ?>

Kontaktní osoba


:
E-mail:


Poptávkový formulář

1.   Termín

Termím konání: -

Termím konání:

Navržený termín:

2.   Počet zájemců

: ,- Kč , ,- Kč

0) { ?>

3.   Další možnosti poptávky


/
,- Kč
,- Kč

3.  











4.   Odeslání poptávky

*